package com.changgou.order.dao;

import com.changgou.order.pojo.MyCollection;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface MyCollectionMapper extends Mapper<MyCollection> {
    /**
     * 根据用户名查询skuid
     * @param username
     * @return
     */
    @Select("select sku_id from tb_collection where username =#{username}")
    public List<Long> findSkuIds(String username);

    @Select("SELECT COUNT(#{username}) FROM tb_collection WHERE username=#{username}")
    public Integer SkuByCount(String username);
}
